CREATE TABLE [dbo].[SmartTechParticipant]
(
[Id] [int] NOT NULL IDENTITY(1, 1),
[Name] [nchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[Mobile] [nchar] (12) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[Email] [nchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[SchoolId] [int] NOT NULL,
[WorkshopId] [int] NOT NULL,
[InterviewId] [int] NOT NULL,
[TimeStamp] [datetime] NOT NULL,
[Online] [bit] NOT NULL,
[Barcode] [nvarchar] (max) COLLATE SQL_Latin1_General_CP1_CI_AS NULL
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
ALTER TABLE [dbo].[SmartTechParticipant] ADD
CONSTRAINT [FK_SmartTechParticipant_SmartTechInterview] FOREIGN KEY ([InterviewId]) REFERENCES [dbo].[SmartTechInterviews] ([Id])
ALTER TABLE [dbo].[SmartTechParticipant] ADD
CONSTRAINT [FK_SmartTechParticipant_College] FOREIGN KEY ([SchoolId]) REFERENCES [dbo].[College] ([Id])
GO
ALTER TABLE [dbo].[SmartTechParticipant] ADD CONSTRAINT [PK_SmartTechRegistration] PRIMARY KEY CLUSTERED  ([Id]) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [IX_SmartTechRegistration] ON [dbo].[SmartTechParticipant] ([Id]) ON [PRIMARY]
GO
ALTER TABLE [dbo].[SmartTechParticipant] ADD CONSTRAINT [FK_SmartTechRegistration_SmartTechWorkshop] FOREIGN KEY ([WorkshopId]) REFERENCES [dbo].[SmartTechWorkshop] ([Id])
GO
